﻿
CREATE VIEW [dbo].[MemberModules]
AS
SELECT			dbo.Members.MemberId as MemberId, 
				dbo.Members.DisplayName, 
				dbo.Members.Email, 
				dbo.Modules.ModuleName, 
				dbo.MembersInModules.ModuleId as ModuleId
				
FROM			dbo.Members 
INNER JOIN		dbo.MembersInModules ON dbo.Members.MemberId = dbo.MembersInModules.MemberId 
INNER JOIN		dbo.Modules ON dbo.MembersInModules.ModuleId = dbo.Modules.ModuleId

